<?php
    include('./gzbdbconn.php');
    $page=$_GET['page'];

    $pages=6;
    $start=($page-1)*$pages;

    $sql="select * from hlw where miaoshu like '%白色%' order by Id limit $start, $pages";

   $result=$conn->query($sql);

   if($result->num_rows>0){

    while($row=mysqli_fetch_assoc($result)){
        $list[]=$row;
    }
    $data['list']=$list;
    $data['code']=1;
   }else{
       $data['code']=0;
   }
   echo json_encode($data);

?>